package edu.dlnu.newbootdemo.dao;

import edu.dlnu.newbootdemo.pojo.Student;
import org.apache.ibatis.annotations.Param;
import org.springframework.stereotype.Repository;

import java.sql.SQLException;
import java.util.List;
@Repository
public interface StudentMapper {
    List<Student> queryAll();
    List<Student> queryByName(String name);
    Student queryByNo(int sno);

    List<Student> queryList(@Param("snos") List<Integer> snos);
    int add(Student s);
    int delete(int sno);
    int update(Student s);
}
